

from common.setting import ensure_path_sep
from utils.mysqlUtils.db_pool import Database

zhcxkj_center_attribute_db= Database(ensure_path_sep("\\config\\shopeev2_config.yaml.bak"), "test_jdw_database")




class Crb_amazon_shelf_template_attributes_19:


    @staticmethod
    def get_origin_field_name_list():
        get_field_name_list = f"""
        SELECT field_name 
        FROM test_zhcxkj_center_attribute.rb_amazon_shelf_template_attributes_19 
        WHERE is_activate=1  
        GROUP BY field_name
        """
        origin_data = zhcxkj_center_attribute_db.fetch_all_tuple(get_field_name_list,())
        origin_data = set(map(lambda x: x[0], origin_data))
        return origin_data